<%@ LANGUAGE="VBScript" %> <% Set Connection = Server.CreateObject("ADODB.Connection") Connection.Mode = adModeRead Connection.Open phdb_rd SQLStmt = "select mms.HYBRID_NPOS,mms.WURST_ID,mms.CHANNEL,mms.SENSOR_POS,mms.SENSOR_ROW,mms.SENSOR_COLUMN " SQLStmt = SQLStmt & " from ASSEMBLY.MOD_MAP_S mms " SQLStmt = SQLStmt & " where mms.MOD_TYPE='" & Request("REQ_MOD_TYPE") & "' ORDER BY mms.HYBRID_NPOS,mms.WURST_ID,mms.CHANNEL " Set RS = Connection.Execute(SQLStmt) 'response.write(SQLStmt) %> Module Map

Module Connection Map for module <%=REQUEST("REQ_MOD_TYPE")%>

Notes:
Hybrid Position is 0 is for all Left hybrids as well as hybrids on Ring and Octagon Modules. Hybrid Position is 1 for all Right hybrids
Sensor Position corresponds to position of sensor in the module
Row and Column are calculated within the system of reference of the silicon sensor (from TYPE_CON table)

<% Do While Not RS.EOF %> <% RS.Movenext Loop %>

Hybrid Position

Wurst_ID

 Channel Sensor Position Row Column
<%=RS("HYBRID_NPOS")%> <%=RS("WURST_ID")%> <%=RS("CHANNEL")%> <%=RS("SENSOR_POS")%> <%=RS("SENSOR_ROW")%> <%=RS("SENSOR_COLUMN")%>
<% Connection.Close %>